package com.example.dao;

import com.example.entity.rental;
import java.util.List;
import java.sql.SQLException;

public interface rentalDao extends Dao{
    //插入方法
    boolean insertRentalData(rental item) throws SQLException;

    //存在判断
    boolean existsByName(String name) throws SQLException;

    // 按时间范围 + 价格区间获取数据
    List<rental> getTodayByAll()  throws SQLException;
    List<rental> getYesterdayByAll() throws SQLException;
    List<rental> getThisWeekByAll()  throws SQLException;
    List<rental> getThisMonthByAll()  throws SQLException;

    List<rental> getTodayBy0To100() throws SQLException;
    List<rental> getYesterdayBy0To100()throws SQLException;
    List<rental> getThisWeekBy0To100()throws SQLException;
    List<rental> getThisMonthBy0To100() throws SQLException;

    List<rental> getTodayBy100To500()throws SQLException;
    List<rental> getYesterdayBy100To500() throws SQLException;
    List<rental> getThisWeekBy100To500()throws SQLException;
    List<rental> getThisMonthBy100To500() throws SQLException;

    List<rental> getTodayBy500To1000() throws SQLException;
    List<rental> getYesterdayBy500To1000() throws SQLException;
    List<rental> getThisWeekBy500To1000()throws SQLException;
    List<rental> getThisMonthBy500To1000() throws SQLException;

    List<rental> getTodayByAbove1000()throws SQLException;
    List<rental> getYesterdayByAbove1000() throws SQLException;
    List<rental> getThisWeekByAbove1000() throws SQLException;
    List<rental> getThisMonthByAbove1000() throws SQLException;
}